﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div style="margin: 0 auto; border: 3px solid #808080; height: auto;">
            <h1 style="text-align: left; color: #b06600">&nbsp;&nbsp;Using LINQ DEMO : Linq to SQL</h1>
            <table style="width: 100%;">
                <tr>
                    <td>&nbsp;&nbsp;
                        <asp:DropDownList ID="ddlTable" runat="server" Height="25px" Width="153px">
                            <asp:ListItem>Select Table..</asp:ListItem>
                            <asp:ListItem>Products</asp:ListItem>
                            <asp:ListItem>Suppliery</asp:ListItem>
                            <asp:ListItem>Category</asp:ListItem>
                        </asp:DropDownList>&nbsp;&nbsp;
                        <asp:Button ID="btnShow" runat="server" Text="Show By Linq" Width="117px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnShow_Click"/>&nbsp;&nbsp;
                        <asp:Button ID="btnRefresh" runat="server" Text="Refresh" Width="78px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnRefresh_Click"/>&nbsp;&nbsp;
                        <asp:DropDownList ID="ddlSearch" runat="server" Height="25px" Width="153px">
                            <asp:ListItem>Select Search..</asp:ListItem>
                            <asp:ListItem>ProductName</asp:ListItem>
                            <asp:ListItem>SupplierID</asp:ListItem>
                            <asp:ListItem>CategoryName</asp:ListItem>
                        </asp:DropDownList>&nbsp;&nbsp;
                        <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>&nbsp;&nbsp;
                        <asp:Button ID="btnSearch" runat="server" Text="Search Products" Width="131px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnSearch_Click" />
                        &nbsp;&nbsp;
                        <asp:Button ID="btnCount" runat="server" Text="Count Supplier" Width="112px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnCount_Click" />&nbsp;&nbsp;
                        <asp:Button ID="btnSum" runat="server" Text="Sumary" Width="78px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnSum_Click"/>&nbsp;&nbsp;
                    </td>

                </tr>
            </table>
        </div>
        <div style="height: auto;">
            <asp:GridView ID="gvwData" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal" Width="100%">
                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F7F7F7" />
                <SortedAscendingHeaderStyle BackColor="#4B4B4B" />
                <SortedDescendingCellStyle BackColor="#E5E5E5" />
                <SortedDescendingHeaderStyle BackColor="#242121" />
            </asp:GridView>
        </div>
    </form>
</body>
</html>
